﻿


-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		09/25/2010 1.0
-- =========================================================================================================
CREATE PROCEDURE [flcr].[api_device_platform_device_type_xref_sel_lov]
@DEVICE_PLATFORM_DEVICE_TYPE_XREF_ID INT

AS
BEGIN
  
	SELECT	[DEVICE_PLATFORM_DEVICE_TYPE_XREF_ID]
	  FROM	[FLCR].[DEVICE_PLATFORM_DEVICE_TYPE_XREF] 
     WHERE	[DEVICE_PLATFORM_DEVICE_TYPE_XREF_ID] = COALESCE(@DEVICE_PLATFORM_DEVICE_TYPE_XREF_ID,[DEVICE_PLATFORM_DEVICE_TYPE_XREF_ID])


END
